/*    */ package com.yc.dao.export;
/*    */ 
/*    */ import btsm.bean.dbConnector;
/*    */ import com.yc.dao.model.AntennaFeederBO;
/*    */ import com.yc.util.FormateSQL;
/*    */ import java.sql.ResultSet;
/*    */ import java.util.ArrayList;
/*    */ import java.util.List;
/*    */ import org.apache.commons.logging.Log;
/*    */ import org.apache.commons.logging.LogFactory;
/*    */ 
/*    */ public class AntennaFeederExportDAO
/*    */   implements IExportAll
/*    */ {
/* 17 */   private static final Log log = LogFactory.getLog(AntennaFeederExportDAO.class);
/*    */ 
/*    */   public List export(dbConnector dbcon, String strBtsName, String strRegistBeginTime, String strRegistEndTime) {
/* 20 */     ResultSet rs = null;
/* 21 */     List list = new ArrayList();
/*    */     try
/*    */     {
/* 24 */       String strSQL = " select * from antennafeeder where btsname like '%" + strBtsName + "%'";
/* 25 */       strSQL = FormateSQL.getFormateSQL(strRegistBeginTime, strRegistEndTime, strSQL);
/* 26 */       log.info(strSQL);
/* 27 */       rs = dbcon.execQuery(strSQL);
/* 28 */       while (rs.next()) {
/* 29 */         AntennaFeederBO bo = new AntennaFeederBO();
/* 30 */         bo.setId(rs.getString("id"));
/* 31 */         bo.setBtscode(rs.getString("btscode"));
/* 32 */         bo.setBtsname(rs.getString("btsname"));
/* 33 */         bo.setAntennaT(rs.getString("antennaT"));
/* 34 */         bo.setAntennaM(rs.getString("antennaM"));
/* 35 */         bo.setAntennaNum(rs.getString("antennaNum"));
/* 36 */         bo.setAntennaPlu(rs.getString("antennaPlu"));
/* 37 */         bo.setAntennaDir(rs.getString("antennaDir"));
/* 38 */         bo.setAntennaPT(rs.getString("antennaPT"));
/* 39 */         bo.setAntennaFB(rs.getString("antennaFB"));
/* 40 */         bo.setAntennaH(rs.getString("antennaH"));
/* 41 */         bo.setAntennaCRD(rs.getString("antennaCRD"));
/* 42 */         bo.setMagnifierT(rs.getString("magnifierT"));
/* 43 */         bo.setMagnifierM(rs.getString("magnifierM"));
/* 44 */         bo.setMagnifierNum(rs.getString("magnifierNum"));
/* 45 */         bo.setMagnifierCell(rs.getString("magnifierCell"));
/* 46 */         bo.setMagnifierCRD(rs.getString("magnifierCRD"));
/* 47 */         bo.setFeederT(rs.getString("feederT"));
/* 48 */         bo.setFeederM(rs.getString("feederM"));
/* 49 */         bo.setFeederLen(rs.getString("feederLen"));
/* 50 */         bo.setFeederNum(rs.getString("feederNum"));
/* 51 */         bo.setMaintenance(rs.getString("maintenance"));
/* 52 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 53 */         bo.setMemo(rs.getString("memo"));
/* 54 */         bo.setAnteIsMakeAng(rs.getString("anteIsMakeAng"));
/* 55 */         bo.setAnteDicAng(rs.getString("anteDicAng"));
/* 56 */         bo.setAnteUpAng(rs.getString("anteUpAng"));
/* 57 */         list.add(bo);
/*    */       }
/*    */     }
/*    */     catch (Exception e) {
/* 61 */       e.printStackTrace();
/* 62 */       log.error(e.getMessage());
/*    */     }
/* 64 */     return list;
/*    */   }
/*    */ }

/* Location:           E:\java\apache-tomcat-6.0.36\webapps\btsm\WEB-INF\classes\
 * Qualified Name:     com.yc.dao.export.AntennaFeederExportDAO
 * JD-Core Version:    0.6.2
 */